<?php /* TASKS $Id: gantt.php,v 1.20.4.13 2007/02/04 12:00:42 gregorerhardt Exp $ */
include ("{$dPconfig['root_dir']}/lib/jpgraph/src/jpgraph.php");
include ("{$dPconfig['root_dir']}/lib/jpgraph/src/jpgraph_gantt.php");

ini_set('max_execution_time', 180);

global $AppUI, $company_id, $dept_ids, $department, $locale_char_set, $proFilter, $pstatus, $showInactive, $showLabels, $showAllGantt, $sortTasksByName, $user_id;

// get the prefered date format
$df = $AppUI->getPref('SHDATEFORMAT');

$pstatus = arrayMerge( array( '-2' => $AppUI->_('All w/o in progress')), $pstatus);
$user_id = dPgetParam($_REQUEST, 'user_id', $AppUI->user_id);
if ($AppUI->user_id == $user_id) {
	$pstatus = arrayMerge( array( '-3' => $AppUI->_('My')), $pstatus);
} else {
	$pstatus = arrayMerge( array( '-3' => $AppUI->_('User\'s')), $pstatus);
}
$proFilter = dPgetParam($_REQUEST, 'proFilter', '-1');
$company_id = dPgetParam($_REQUEST, 'company_id', 0);
$department = dPgetParam($_REQUEST, 'department', 0);
$showLabels = dPgetParam($_REQUEST, 'showLabels', 0);
$showInactive = dPgetParam($_REQUEST, 'showInactive', 0);
$sortTasksByName = dPgetParam($_REQUEST, 'sortTasksByName', 0);
$addPwOiD = dPgetParam($_REQUEST, 'addPwOiD', 0);

$pjobj =& new CProject;
$working_hours = $dPconfig['daily_working_hours'];

/*
 ** Load department info for the case where one
 ** wants to see the ProjectsWithOwnerInDeparment (PwOiD)
 ** instead of the projects related to the given department.
 */
if ($addPwOiD && $department>0) {
	$owner_ids = array();
	$q = new DBQuery;
	$q->addTable('users');
	$q->addQuery('user_id');
	$q->addJoin('contacts', 'c', 'c.contact_id = user_contact');
	$q->addWhere('c.contact_department = '.$department);
	$owner_ids = $q->loadColumn();
	$q->clear();
}

// pull valid projects and their percent complete information
// GJB: Note that we have to special case duration type 24 and this refers to the hours in a day, NOT 24 hours
$q  = new DBQuery;
$q->addTable('projects', 'p');
$q->addQuery('DISTINCT p.project_id, project_color_identifier, project_name, project_start_date, project_end_date,
		max(t1.task_end_date) AS project_actual_end_date, SUM(task_duration * task_percent_complete *
			IF(task_duration_type = 24, '.$working_hours.', task_duration_type))/ SUM(task_duration *
			IF(task_duration_type = 24, '.$working_hours.', task_duration_type)) AS project_percent_complete,
		project_status');
$q->addJoin('tasks', 't1', 'p.project_id = t1.task_project');
$q->addJoin('companies', 'c1', 'p.project_company = c1.company_id');
if ($department > 0) {
	$q->addJoin('project_departments', 'pd', 'pd.project_id = p.project_id');
}
if ($department > 0 && !$addPwOiD) {
	$q->addWhere('pd.department_id = '.$department);
}
if ($proFilter == '-3'){
	$q->addWhere('project_owner = '.$user_id);
} else if ($proFilter == '-2'){
	$q->addWhere('project_status != 3');
} else if ($proFilter != '-1') {
	$q->addWhere('project_status = '.$proFilter);
}
if (!($department > 0) && $company_id != 0 && !$addPwOiD) {
	$q->addWhere('project_company = '.$company_id);
}
// Show Projects where the Project Owner is in the given department
if ($addPwOiD && !empty($owner_ids))
	$q->addWhere('p.project_owner IN ('.implode(',', $owner_ids).')');

if ($showInactive != '1') {
	$q->addWhere('project_status != 7');
}
$pjobj->setAllowedSQL($AppUI->user_id, $q);
$q->addGroup('project_id');
$q->addOrder('project_name, task_end_date DESC');
$projects = $q->loadList();
$q->clear();

$width      = dPgetParam( $_GET, 'width', 600 );
$start_date = dPgetParam( $_GET, 'start_date', 0 );
$end_date   = dPgetParam( $_GET, 'end_date', 0 );

$showAllGantt = dPgetParam( $_REQUEST, 'showAllGantt', '0' );
//$showTaskGantt = dPgetParam( $_GET, 'showTaskGantt', '0' );

$graph = new GanttGraph($width);
$graph->ShowHeaders(GANTT_HYEAR | GANTT_HMONTH | GANTT_HDAY | GANTT_HWEEK);

$graph->SetFrame(false);
$graph->SetBox(true, array(0,0,0), 2);
$graph->scale->week->SetStyle(WEEKSTYLE_FIRSTDAY);

//stable_2 still has jpLocale config variable
$jpLocale = dPgetConfig( 'jpLocale' );
if ($jpLocale) {
	$graph->scale->SetDateLocale( $jpLocale );
}
else {
	$graph->scale->SetDateLocale( $AppUI->user_lang[2] );
}

if ($start_date && $end_date) {
	$graph->SetDateRange( $start_date, $end_date );
}

$graph->scale->actinfo->SetFont(FF_ARIAL);
$graph->scale->actinfo->vgrid->SetColor('gray');
$graph->scale->actinfo->SetColor('darkgray');
$graph->scale->actinfo->SetColTitles(array( $AppUI->_('Project', UI_OUTPUT_RAW), $AppUI->_('Start', UI_OUTPUT_RAW), $AppUI->_('Finish', UI_OUTPUT_RAW), $AppUI->_('Actual End', UI_OUTPUT_RAW)),array(160,60, 60,60));


$tableTitle = ($proFilter == '-1') ? $AppUI->_('All Projects') : $pstatus[$proFilter].' Projects';
$graph->scale->tableTitle->Set($tableTitle);

// Use TTF font if it exists
// try commenting out the following two lines if gantt charts do not display
if (is_file( TTF_DIR."arialbd.ttf" )) {
	$graph->scale->tableTitle->SetFont(FF_ARIAL,FS_BOLD,12);
}
$graph->scale->SetTableTitleBackground("#eeeeee");
$graph->scale->tableTitle->Show(true);

//-----------------------------------------
// nice Gantt image
// if diff(end_date,start_date) > 90 days it shows only
//week number
// if diff(end_date,start_date) > 240 days it shows only
//month number
//-----------------------------------------
if ($start_date && $end_date){
	$min_d_start = new CDate($start_date);
	$max_d_end = new CDate($end_date);
	$graph->SetDateRange( $start_date, $end_date );
} else {
	// find out DateRange from gant_arr
	$d_start = new CDate();
	$d_end = new CDate();
	for($i = 0; $i < count(@$projects); $i++ ){
		$start = substr($p["project_start_date"], 0, 10);
		$end = substr($p["project_end_date"], 0, 10);

		$d_start->Date($start);
		$d_end->Date($end);

		if ($i == 0){
			$min_d_start = $d_start;
			$max_d_end = $d_end;
		} else {
			if (Date::compare($min_d_start,$d_start)>0){
				$min_d_start = $d_start;
			}
			if (Date::compare($max_d_end,$d_end)<0){
				$max_d_end = $d_end;
			}
		}
	}
}

// check day_diff and modify Headers
$day_diff = $min_d_start->dateDiff($max_d_end);

if ($day_diff > 240){
	//more than 240 days
	$graph->ShowHeaders(GANTT_HYEAR | GANTT_HMONTH);
} else if ($day_diff > 90){
	//more than 90 days and less of 241
	$graph->ShowHeaders(GANTT_HYEAR | GANTT_HMONTH | GANTT_HWEEK );
	$graph->scale->week->SetStyle(WEEKSTYLE_WNBR);
}
$graph->scale->day->SetFont(FF_ARIAL,FS_NORMAL,7);
$graph->scale->week->SetFont(FF_ARIAL,FS_BOLD,8);
$graph->scale->month->SetFont(FF_ARIAL,FS_BOLD,8);
$graph->scale->year->SetFont(FF_ARIAL,FS_BOLD,10);

$row = 0;

if (!is_array($projects) || sizeof($projects) == 0) {
	$d = new CDate();
	$bar = new GanttBar($row++, array(' '.$AppUI->_('No projects found'),  ' ', ' ', ' '), $d->getDate(), $d->getDate(), ' ', 0.6);
	$bar->title->SetFont(FF_ARIAL,FS_NORMAL,10);
	$bar->title->SetColor('red');
	$graph->Add($bar);
}

if (is_array($projects)) {
	foreach($projects as $p) {

		if ( $locale_char_set=='utf-8' && function_exists("utf8_decode") ) {
			$name = strlen( utf8_decode($p["project_name"]) ) > 25 ? substr( utf8_decode($p["project_name"]), 0, 22 ).'...' : utf8_decode($p["project_name"]) ;
		} else {
			//while using charset different than UTF-8 we need not to use utf8_deocde
			$name = strlen( $p["project_name"] ) > 25 ? substr( $p["project_name"], 0, 22 ).'...' : $p["project_name"] ;
		}

		//using new jpGraph determines using Date object instead of string
		$start = ($p["project_start_date"] > "0000-00-00 00:00:00") ? $p["project_start_date"] : date("Y-m-d H:i:s");
		$end_date   = $p["project_end_date"];


		$end_date = new CDate($end_date);
		//	$end->addDays(0);
		$end = $end_date->getDate();

		$start = new CDate($start);
		//	$start->addDays(0);
		$start = $start->getDate();

		$progress = $p['project_percent_complete'] + 0;

		$caption = "";
		if(!$start || $start == "0000-00-00"){
			$start = !$end ? date("Y-m-d") : $end;
			$caption .= $AppUI->_("(no start date)");
		}

		if(!$end) {
			$end = $start;
			$caption .= " ".$AppUI->_("(no end date)");
		} else {
			$cap = "";
		}

		if ($showLabels){
			$caption .= $AppUI->_($pstatus[$p['project_status']]).", ";
			$caption .= $p['project_status'] <> 7 ? $AppUI->_('active') : $AppUI->_('archived');
		}
		$enddate = new CDate($end);
		$startdate = new CDate($start);
		$actual_end = $p["project_actual_end_date"] ? $p["project_actual_end_date"] : $end;

		$actual_enddate = new CDate($actual_end);
		$actual_enddate = $actual_enddate->after($startdate) ? $actual_enddate : $enddate;
		$bar = new GanttBar($row++, array($name, $startdate->format($df), $enddate->format($df), $actual_enddate->format($df)), $start, $actual_end, $cap, 0.6);
		$bar->progress->Set(min(($progress/100), 1));

		$bar->title->SetFont(FF_ARIAL,FS_NORMAL,8);
		$bar->SetFillColor("#".$p['project_color_identifier']);
		$bar->SetPattern(BAND_SOLID,"#".$p['project_color_identifier']);

		//adding captions
		$bar->caption = new TextProperty($caption);
		$bar->caption->Align("left","center");

		// gray out templates, completes, on ice, on hold
		if ($p['project_status'] != '3' || $p['project_status'] == '7') {
			$bar->caption->SetColor('darkgray');
			$bar->title->SetColor('darkgray');
			$bar->SetColor('darkgray');
			$bar->SetFillColor('gray');
			//$bar->SetPattern(BAND_SOLID,'gray');
			$bar->progress->SetFillColor('darkgray');
			$bar->progress->SetPattern(BAND_SOLID,'darkgray',98);
		}

		$graph->Add($bar);

		// If showAllGant checkbox is checked
		if ($showAllGantt) {
			// insert tasks into Gantt Chart

			// select for tasks for each project

			$q  = new DBQuery;
			$q->addTable('tasks');
			$q->addQuery('DISTINCT tasks.task_id, tasks.task_name, tasks.task_start_date, tasks.task_end_date, tasks.task_milestone, tasks.task_dynamic');
			$q->addJoin('projects', 'p', 'p.project_id = tasks.task_project');
			$q->addWhere('p.project_id = '. $p['project_id']);
			if ($sortTasksByName)
				$q->addOrder('tasks.task_name');
			else
				$q->addOrder('tasks.task_end_date ASC');
			$tasks = $q->loadList();
			$q->clear();
			foreach($tasks as $t) {
				if ($t["task_end_date"] == null)
					$t["task_end_date"] = $t["task_start_date"];

				$tStart = ($t["task_start_date"] > "0000-00-00 00:00:00") ? $t["task_start_date"] : date("Y-m-d H:i:s");
				$tEnd = ($t["task_end_date"] > "0000-00-00 00:00:00") ? $t["task_end_date"] : date("Y-m-d H:i:s");
				$tStartObj = new CDate($tStart);
				$tEndObj = new CDate($tEnd);

				if ($t["task_milestone"] != 1) {
					$bar2 = new GanttBar($row++, array(substr(" --".$t["task_name"], 0, 20)."...", $tStartObj->format($df),  $tEndObj->format($df), ' '), $tStart, $tEnd, ' ', $t['task_dynamic'] == 1 ? 0.1 : 0.6);

					$bar2->title->SetColor( bestColor( '#ffffff', '#'.$p['project_color_identifier'], '#000000' ) );
					$bar2->SetFillColor("#".$p['project_color_identifier']);
					$graph->Add($bar2);
				}
				else {
					$bar2  = new MileStone ($row++, "-- " . $t["task_name"], $t["task_start_date"], $tStartObj->format($df));
					$bar2->title->SetColor("#CC0000");
					$graph->Add($bar2);
				}

				// Insert workers for each task into Gantt Chart
				$q  = new DBQuery;
				$q->addTable('user_tasks', 't');
				$q->addQuery('DISTINCT user_username, t.task_id');
				$q->addJoin('users', 'u', 'u.user_id = t.user_id');
				$q->addWhere("t.task_id = ".$t["task_id"]);
				$q->addOrder('user_username ASC');
				$workers = $q->loadList();
				$q->clear();
				$workersName = "";
				foreach($workers as $w) {
					$workersName .= " ".$w["user_username"];

					$bar3 = new GanttBar($row++, array("   * ".$w["user_username"], " ", " "," "), $tStartObj->format(FMT_DATETIME_MYSQL), $tEndObj->format(FMT_DATETIME_MYSQL), 0.6);
					$bar3->title->SetColor(bestColor( '#ffffff', '#'.$p['project_color_identifier'], '#000000' ));
					$bar3->SetFillColor("#".$p['project_color_identifier']);
					$graph->Add($bar3);
				}
				// End of insert workers for each task into Gantt Chart
			}
			// End of insert tasks into Gantt Chart
		}
		// End of if showAllGant checkbox is checked
	}
} // End of check for valid projects array.

$today = date("y-m-d");
$vline = new GanttVLine($today, $AppUI->_('Today', UI_OUTPUT_RAW), 'blue');
$vline->title->SetFont(FF_ARIAL, FS_BOLD, 9);
$vline->title->SetColor('blue');
$graph->Add($vline);
$graph->Stroke();
?>
